package com.trkj.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.trkj.pojos.JlCheckProject;

public interface IJlCheckProjectDAO extends CrudRepository<JlCheckProject, Long> {
	@Query("select s from JlCheckProject s ")
	public List<JlCheckProject> finCheckProjectpage(Pageable pageable);
	@Query("select s from JlCheckProject s ")
	public List<JlCheckProject> queryAll();
	@Query("select s from JlCheckProject s where kind=?1")
	public List<JlCheckProject>  checkProjKind (String sex); 
	@Query("select s from JlCheckProject s where cprProject=?1")
	public List<JlCheckProject>  checkProjPJ(String sex); 
	@Query("select cprNum from JlCheckProject  where cprProject=?1")
	public BigDecimal checkmoney(String cprProject); 
			
		
}
